# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月18日
"""
import openpyxl

myBook = openpyxl.load_workbook('收入表.xlsx')
mySheet=myBook.active
for myCol in range(1,5):
	if myCol %2==0:
		myColLetter=openpyxl.utils.get_column_letter(myCol)
		for myRow in range(5,9):
			mySheet[myColLetter+str(myRow)]=''
myBook.save('收入表.xlsx')